UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lqCUBZgPlUIUjQ7OoB9SUPyy/v3ls/pVdOed6hQ/13Q=' 
WHERE 
  key_id = '469f0c402d12e21b8485bcbe66649c54680a9f3093ee5ec25075850c88c426de' 
  AND (
    token = 'lqCUBZgPlUIUjQ7OoB9SUPyy/v3ls/pVdOed6hQ/13Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036