UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yH79w8mCSsPoEJoCab3GlB0cMVVpCLuEy1Tdi6WxPd4='
WHERE
key_id = 'bb7a2f6cf9b23cd068f197b7efc2cb8ec36735ad7e9d468cb108ce8e788dff78'
AND (
token = 'yH79w8mCSsPoEJoCab3GlB0cMVVpCLuEy1Tdi6WxPd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)