UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XVyeFScIu8uL+mZZwm3nPK0+6B60CAuBxeYTGphsppc=' 
WHERE 
  key_id = '610f5022e2b80633315c9d4c13751e61cc5852abc9843b5e8881dd1cc33e8525' 
  AND (
    token = 'XVyeFScIu8uL+mZZwm3nPK0+6B60CAuBxeYTGphsppc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026