UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tyRIXfoMGJi7sGF1W1bT1ivo3sviOpkgSL5qZlRi+20=' 
WHERE 
  key_id = '526bc44755c7ce59c4b261e94c32e1ad7cdbcbd54171fd955bc7532d6cba2a29' 
  AND (
    token = 'tyRIXfoMGJi7sGF1W1bT1ivo3sviOpkgSL5qZlRi+20=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020