UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PqgJaEyKUS4JeMEJtpHye/fhT768mUEkLNbuuwg/EtA='
WHERE
key_id = 'bd1d349a419381df19b314d68626b33a97512964a1b25f0d19af809eaafaab0c'
AND (
token = 'PqgJaEyKUS4JeMEJtpHye/fhT768mUEkLNbuuwg/EtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)