UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TYu23IvMUE0UhOgK15gqOBCGc6m8mG2q/yKiiYYMuyE='
WHERE
key_id = 'd8bd93964662c020dde1dc26846f5d2a2a3c67609725051150d36c32b85a3e5e'
AND (
token = 'TYu23IvMUE0UhOgK15gqOBCGc6m8mG2q/yKiiYYMuyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)