UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N7lviYaF1d8SE/gZmrQpPyxotbEe24VfEedB87k6S5Q='
WHERE
key_id = '674cf1bc968fd9fc7dc4cbfd1bf0cc473104e34cbd060fcc8074c8321ae5efb1'
AND (
token = 'N7lviYaF1d8SE/gZmrQpPyxotbEe24VfEedB87k6S5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)