UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DI/d78ipc8ygtN2pUppTTywPWSHZzxTlhybHnV8OCb0='
WHERE
key_id = '1b49bd9e40d63d5667feef218d9bf795d9bec1eff89e8f7f2979ae7b41bf4c11'
AND (
token = 'DI/d78ipc8ygtN2pUppTTywPWSHZzxTlhybHnV8OCb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)