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