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