UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PvU6ORNhfsUVvst1JUm28Q6j568GvlrQN4hjJ2jxyX8=' 
WHERE 
  key_id = 'c56e28291038e66ab8120ae20d5c02ae63bfd1de4f29fe3b0a6b1c434d3e8ced' 
  AND (
    token = 'PvU6ORNhfsUVvst1JUm28Q6j568GvlrQN4hjJ2jxyX8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034