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