UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YeO83MfrN+mx+a/LHo+Z7ghdKXIk4zW13EIsxjnezpc=' 
WHERE 
  key_id = '1d54c599578e601ecae46a7c0de257f4918fc812309ef8cc7e2746deb99428f7' 
  AND (
    token = 'YeO83MfrN+mx+a/LHo+Z7ghdKXIk4zW13EIsxjnezpc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035