UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eOg4tVmxhMu5yecrSsWWS8JYDHG1WPklagqSnFFE/sA=' 
WHERE 
  key_id = 'b38e6b59a82ba35a6299183a6acc591dbe45feea1987b62c74ae75d83e6a1484' 
  AND (
    token = 'eOg4tVmxhMu5yecrSsWWS8JYDHG1WPklagqSnFFE/sA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019