UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8X7wg1Zibw1nZODLNaY9Ivj8mgxhzf8afS95xfJwCbY='
WHERE
key_id = '70a86bfca2a6bb19a3c2de0850d710a662135a5cd0686715b37c03c2d78b6a11'
AND (
token = '8X7wg1Zibw1nZODLNaY9Ivj8mgxhzf8afS95xfJwCbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)