UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z3tYuCVptiii5X093pCsiGvkR8oh1kDPWRLgH7XXO1w='
WHERE
key_id = '971efc03461aa7b8d8368ebca82e383ac9c3465d1772da23d8f852eea17491ac'
AND (
token = 'Z3tYuCVptiii5X093pCsiGvkR8oh1kDPWRLgH7XXO1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)