UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E/HbvadpOeOJdkV6VDB5Vw0EldF8wjSyZE9ui3o+bZ8='
WHERE
key_id = 'd3b4c87c4f631dbbc71f9e46aee614d338c274504ab3d389819b07ceff8708e5'
AND (
token = 'E/HbvadpOeOJdkV6VDB5Vw0EldF8wjSyZE9ui3o+bZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)