UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnGsJFC+qavMF6CI965LMUKZ+hxIiB31joMC2Rdnzuk='
WHERE
key_id = '5b97a6f41e37c06f46f88b30ce97b8229e753102cff483b79ae4f6f41883f591'
AND (
token = 'ZnGsJFC+qavMF6CI965LMUKZ+hxIiB31joMC2Rdnzuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)