UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6VQCAC4sGiHkw03jVvpBFdT3wvADDskAuAkD3ZNfYis='
WHERE
key_id = '9512a7f7e50d42647b3c210e43b181f41bd273963c4173b26c3947cc284e6015'
AND (
token = '6VQCAC4sGiHkw03jVvpBFdT3wvADDskAuAkD3ZNfYis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)