UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jjxwgcVX34+x4G9xSNSObzs5srj4BCQyaBWX/sN7VYk=' 
WHERE 
  key_id = '6d560af608607e09ee9d49af2daa8b7e1593b9351fce68758809bc2cf48b3464' 
  AND (
    token = 'jjxwgcVX34+x4G9xSNSObzs5srj4BCQyaBWX/sN7VYk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032