UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aYf5UEHRE7pUDjdUBU7fP8/F+tEPDSB5+uhLu75cYYg=' 
WHERE 
  key_id = '314a80f91d6f7f55ad9dc0c8a9eea6b9673753833d52a6c55c30c68230ef22f2' 
  AND (
    token = 'aYf5UEHRE7pUDjdUBU7fP8/F+tEPDSB5+uhLu75cYYg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026