UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNEPlZXoSK29ws7zDICCVG+1NQDHwL4gp/x7hlxWcSc='
WHERE
key_id = '22e5ec8fddf51dc95cb4bfe76c13f021a31c6dcdc1249ccc93ddc974cf1b69e6'
AND (
token = 'ZNEPlZXoSK29ws7zDICCVG+1NQDHwL4gp/x7hlxWcSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)