UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zrYnLn5ZG2WJfdNa9d2VOgQdj0tUZpNic5sc/fG69/k='
WHERE
key_id = '40cfecaba4965e5f0be6a43473642e8aa4620267931ca5e8c9c49a34aa6907bb'
AND (
token = 'zrYnLn5ZG2WJfdNa9d2VOgQdj0tUZpNic5sc/fG69/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)