UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEnhRjvajy/SKMF4u0BS97VGW+Xi0hcZCBUIHT+bLew='
WHERE
key_id = 'cfde5754eb12e9ccf5b5776a85908d102fbbf1b251136c9b1eeaf0aae33bb9b5'
AND (
token = 'zEnhRjvajy/SKMF4u0BS97VGW+Xi0hcZCBUIHT+bLew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)