UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+dxMIj4bOLuxFi6v1MCe+A9zI1JsuBn/dy1nmAqPKcA=' 
WHERE 
  key_id = '2667fa9510fa0c4e6e13e1e8c17521e5ac92966349e64196ddbd79b8a9967721' 
  AND (
    token = '+dxMIj4bOLuxFi6v1MCe+A9zI1JsuBn/dy1nmAqPKcA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030