UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JnFz+bJhvTGJ5CtOKmyx5G/UfPZDTXr250DLvXsKENo='
WHERE
key_id = 'c9be814b67d7d79af9237b1be8fac76111f7a61085b741cf2261250e5327def4'
AND (
token = 'JnFz+bJhvTGJ5CtOKmyx5G/UfPZDTXr250DLvXsKENo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)