UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vMTFU1iFthPcpJk8NRHZEfL83QOg9/7FKV3M09U+gCE='
WHERE
key_id = 'fe0fc8e55b3ab181ed14ae35f15e98c75747e9bcd67e8b90a90a315c7bf57314'
AND (
token = 'vMTFU1iFthPcpJk8NRHZEfL83QOg9/7FKV3M09U+gCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)