UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nyH1tdZS0eDZ73l8/5ANAmwvcdkBfCpX6claVtF4EnY='
WHERE
key_id = 'd2cc1b63350a55c88be45c1adff19640ff016981fed909ddc81dcd7cd9bf0a49'
AND (
token = 'nyH1tdZS0eDZ73l8/5ANAmwvcdkBfCpX6claVtF4EnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)