UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnzpuSdiFYl+8lSk8BVKi6+UFmytZUyBpD601H9eyr4='
WHERE
key_id = '9ffb868c909b32bd0f2549a67f7b9bbf9f1366e2e9f01413339c30c3da9b9ef7'
AND (
token = 'ZnzpuSdiFYl+8lSk8BVKi6+UFmytZUyBpD601H9eyr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)