UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PWPq9lic4Oyhwwmnj0dIv0xLz78YdeOUxNULUGNjUZM=' 
WHERE 
  key_id = '273b7b5292e93f29c9267ed1f9ba0fc8653bf2422128a5576c60284503de76a3' 
  AND (
    token = 'PWPq9lic4Oyhwwmnj0dIv0xLz78YdeOUxNULUGNjUZM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048