UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCpNwZ1WGOeneT3lo2K9qw1CJ3zrlWg+/r+8sHwdyVk='
WHERE
key_id = '9be77303e07fad7ed589ee8bc9d114c81d5f7562577aadefa4d142c641eb3668'
AND (
token = 'ZCpNwZ1WGOeneT3lo2K9qw1CJ3zrlWg+/r+8sHwdyVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)