UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pIzepkbPM61VbUJAjspSyZMdfucS64aztTDS7ZPkEAk='
WHERE
key_id = '3847b8638e0f39bd4df2d4091ef204ee6173eb35b6ba79397f3ac6d2c60114e1'
AND (
token = 'pIzepkbPM61VbUJAjspSyZMdfucS64aztTDS7ZPkEAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)