UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YXDl35OPYfEDIL6mTKUJHVbdDFNyDOMH+eEL59m1+w4='
WHERE
key_id = '9f4c2f9d4457c77a72adf2c04cbf2bf214e4ddc89d89f98775427ebfbc1e6306'
AND (
token = 'YXDl35OPYfEDIL6mTKUJHVbdDFNyDOMH+eEL59m1+w4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)