UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uFtCZdjcOP8n/0eUN5ur3aD3EL3Dx3JV+oLW869X1Y0=' 
WHERE 
  key_id = '51349dc52bc605e3124680b536687f914d8b7a717975211dd4ea4e7161b75a37' 
  AND (
    token = 'uFtCZdjcOP8n/0eUN5ur3aD3EL3Dx3JV+oLW869X1Y0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022