UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NXBjqH1+mF/fOeafP+RIrKTdlpG4R/xrE9I973LwKXk='
WHERE
key_id = '8e17dd968787b149406b7d3ffdfb63c0cb184ecb12c29104e8baf5f9383b8db0'
AND (
token = 'NXBjqH1+mF/fOeafP+RIrKTdlpG4R/xrE9I973LwKXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)