UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/np2zUBpe7nXB9uFd6ojKBx6G7Q68a85RjfVbxhglh8='
WHERE
key_id = 'cbacf79199a0c3cee4eae792e167cc049fc3d5e803f10947b032deb5527cf890'
AND (
token = '/np2zUBpe7nXB9uFd6ojKBx6G7Q68a85RjfVbxhglh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)