UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNvmcqdA5N2j7OKGJkdoAjO2ITuqgp4Xvdhd1udfrZc='
WHERE
key_id = 'd36a1f9a37c03b8eabe0452ff1679690cd7e92b292016a7f618c19874aaa9996'
AND (
token = 'KNvmcqdA5N2j7OKGJkdoAjO2ITuqgp4Xvdhd1udfrZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)