UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xITcM6/eEBHQ62TaTDVm/IVCgV0q206iKZCIiRaY7oM='
WHERE
key_id = 'd30ab35f2f0b17447df135d2886e262f4cbd0f6ac6d4f7686a6c101288a4ee9d'
AND (
token = 'xITcM6/eEBHQ62TaTDVm/IVCgV0q206iKZCIiRaY7oM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)