UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0UQOgonebC/1qprmlnnG2DAK7GvJ5Elgl/6FELHtYvY='
WHERE
key_id = '65a6975e65e0d85d5d682ed747e32ddc526de8a5ba599fc224170b38cc67e980'
AND (
token = '0UQOgonebC/1qprmlnnG2DAK7GvJ5Elgl/6FELHtYvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)