UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+4pyRnesNSisim+JCSu4/ZK2s/xNE2ussRCRV2pP9Gs='
WHERE
key_id = 'a462579aabb47244cb93ac6f0ac746007733d36aeea1590bde9e59f67ac4813f'
AND (
token = '+4pyRnesNSisim+JCSu4/ZK2s/xNE2ussRCRV2pP9Gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)