UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Jc31bp2iC1CH/YzzeY1+Lo+hvHVrmIkDJOQ4IZ1Ia4='
WHERE
key_id = '965ba1b632d3fae6d93fef39775ac0f683f419e23ae3406479d9bc8a4b22cce5'
AND (
token = '7Jc31bp2iC1CH/YzzeY1+Lo+hvHVrmIkDJOQ4IZ1Ia4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)