UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJ3JlOFYX2piOS3oqYou+VE4N2okAn8OSB/OAgxdNBk='
WHERE
key_id = 'e76579adbfcfd3c6ce0c66cb030a695148ce27de604153b42854dfbfcfc33ed1'
AND (
token = 'BJ3JlOFYX2piOS3oqYou+VE4N2okAn8OSB/OAgxdNBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)