UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hx0TyvbbgZsOxkzefiNUbvIwFqaVMY3dW9SBrmsKKM0='
WHERE
key_id = 'fa81b030e2446f9ae9011fe19595eb44f48173a8027c1b66bf6b153a23028c7e'
AND (
token = 'hx0TyvbbgZsOxkzefiNUbvIwFqaVMY3dW9SBrmsKKM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)