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