UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pFSMxBbjanUMa5tJ5LId/iT/X22SFy5AKXHlnlD6HEo=' 
WHERE 
  key_id = '16178e1f16510f06f7aae2faf60eb02c7ca191948a5d23e9914e8b6f959f3918' 
  AND (
    token = 'pFSMxBbjanUMa5tJ5LId/iT/X22SFy5AKXHlnlD6HEo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016