UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BdFAnKVZ3l0j2c+nqVjNLIHDe/GkdyPlCoifIWa4DXw=' 
WHERE 
  key_id = 'a725b6d363a745e379e87dcc4edd5e2de9c1e972e8925625c5e17e9c54c8ed84' 
  AND (
    token = 'BdFAnKVZ3l0j2c+nqVjNLIHDe/GkdyPlCoifIWa4DXw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045