UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+R0TZjrxYweY3eyE0AnIrbraWi+UPcoc/y1wHv+En5I=' 
WHERE 
  key_id = '9cdd4dd646b608e8669a31c995c5da19535a0850452bfb77beb5e7eae3a742b4' 
  AND (
    token = '+R0TZjrxYweY3eyE0AnIrbraWi+UPcoc/y1wHv+En5I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024