UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xy9PayCFOPimtipekOn3jAXKVIJZmaE2PYMbee2KI1s='
WHERE
key_id = '6dac812166ad3fd345327aa96e5c190823034defdf44824ba243c1f3702012ee'
AND (
token = 'Xy9PayCFOPimtipekOn3jAXKVIJZmaE2PYMbee2KI1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)